Period datetime64[ns] sector_housing float64 dtype: object
| Period | Institution_Name | Deposits_by_households | Total_residents_loans_and_finance_leases | Total_residents_deposits | Total_Housing_Loans | Loans_to_households:_Credit_cards | Loans_to_households:_Other | DLR | Deposit/Asset | Sector | Sector2 | sector_housing | sector_creditcards | sector_OtherLoans | sector_DLR | sector_Deposit/Asset | sector_Total_residents_deposits | sector_Total_residents_loans_and_finance_leases | sum_depo | sum_loans | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2022-07-31 | Arab Bank Australia Limited | 366.9 | 822.0 | 902.9 | 491.6 | 0.0 | 47.3 | 1.098418 | 0.700955 | Other Banks | NaN | 841.233333 | 1.233333 | 18.266667 | 1.066685 | 0.726579 | 1062.133333 | 995.733333 | 3186.4 | 2987.2 |
| 8 | 2022-07-31 | Australian Unity Bank Limited | 813.4 | 1126.6 | 1236.1 | 1025.5 | 3.7 | 6.3 | 1.097195 | 0.780514 | Other Banks | NaN | 841.233333 | 1.233333 | 18.266667 | 1.066685 | 0.726579 | 1062.133333 | 995.733333 | 3186.4 | 2987.2 |
| 23 | 2022-07-31 | BNK Banking Corporation Limited | 506.4 | 1038.6 | 1047.4 | 1006.6 | 0.0 | 1.2 | 1.008473 | 0.698267 | Other Banks | NaN | 841.233333 | 1.233333 | 18.266667 | 1.066685 | 0.726579 | 1062.133333 | 995.733333 | 3186.4 | 2987.2 |
| 129 | 2022-06-30 | Arab Bank Australia Limited | 370.0 | 825.1 | 895.3 | 494.4 | 0.0 | 48.5 | 1.085081 | 0.699891 | Other Banks | NaN | 636.850000 | 0.975000 | 13.700000 | 1.094472 | 0.702703 | 828.625000 | 757.100000 | 3314.5 | 3028.4 |
| 135 | 2022-06-30 | Australian Unity Bank Limited | 830.7 | 1107.0 | 1192.9 | 1004.5 | 3.9 | 4.9 | 1.077597 | 0.776526 | Other Banks | NaN | 636.850000 | 0.975000 | 13.700000 | 1.094472 | 0.702703 | 828.625000 | 757.100000 | 3314.5 | 3028.4 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 5010 | 2019-04-30 | MyLifeMyFinance Limited | 87.3 | 77.2 | 105.3 | 75.0 | 0.0 | 1.7 | 1.363990 | 0.823299 | Other Banks | NaN | 294.450000 | 1.100000 | 13.525000 | 1.155170 | 0.801561 | 484.825000 | 419.700000 | 1939.3 | 1678.8 |
| 5062 | 2019-03-31 | Arab Bank Australia Limited | 331.1 | 671.5 | 788.9 | 337.4 | 0.0 | 48.1 | 1.174832 | 0.788742 | Other Banks | NaN | 290.175000 | 1.200000 | 13.700000 | 1.148144 | 0.813380 | 477.800000 | 416.150000 | 1911.2 | 1664.6 |
| 5067 | 2019-03-31 | Australian Unity Bank Limited | 662.9 | 726.3 | 785.8 | 593.0 | 4.8 | 3.3 | 1.081922 | 0.916385 | Other Banks | NaN | 290.175000 | 1.200000 | 13.700000 | 1.148144 | 0.813380 | 477.800000 | 416.150000 | 1911.2 | 1664.6 |
| 5108 | 2019-03-31 | Goldfields Money Limited | 93.8 | 192.1 | 232.6 | 157.8 | 0.0 | 1.7 | 1.210828 | 0.697451 | Other Banks | NaN | 290.175000 | 1.200000 | 13.700000 | 1.148144 | 0.813380 | 477.800000 | 416.150000 | 1911.2 | 1664.6 |
| 5135 | 2019-03-31 | MyLifeMyFinance Limited | 84.1 | 74.7 | 103.9 | 72.5 | 0.0 | 1.7 | 1.390897 | 0.850942 | Other Banks | NaN | 290.175000 | 1.200000 | 13.700000 | 1.148144 | 0.813380 | 477.800000 | 416.150000 | 1911.2 | 1664.6 |
163 rows × 21 columns
| Period | Institution_Name | Deposits_by_households | Total_residents_loans_and_finance_leases | Total_residents_deposits | Total_Housing_Loans | Loans_to_households:_Credit_cards | Loans_to_households:_Other | DLR | Deposit/Asset | Sector | Sector2 | sector_housing | sector_creditcards | sector_OtherLoans | sector_DLR | sector_Deposit/Asset | sector_Total_residents_deposits | sector_Total_residents_loans_and_finance_leases | sum_depo | sum_loans | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 2022-07-31 | AMP Bank Limited | 8684.0 | 22752.3 | 13495.1 | 20993.8 | 0.0 | 478.7 | 0.593131 | 0.421779 | 2nd Tier Banks | NaN | 56274.620000 | 178.64 | 2238.640000 | 0.882939 | 0.530420 | 62691.540000 | 71003.280000 | 313457.7 | 355016.4 |
| 17 | 2022-07-31 | Bank of Queensland Limited | 31241.5 | 75032.1 | 65544.9 | 60449.8 | 181.2 | 570.0 | 0.873558 | 0.570837 | 2nd Tier Banks | NaN | 56274.620000 | 178.64 | 2238.640000 | 0.882939 | 0.530420 | 62691.540000 | 71003.280000 | 313457.7 | 355016.4 |
| 21 | 2022-07-31 | Bendigo and Adelaide Bank Limited | 41023.2 | 75812.8 | 68740.7 | 57393.3 | 285.4 | 1806.3 | 0.906716 | 0.625299 | 2nd Tier Banks | NaN | 56274.620000 | 178.64 | 2238.640000 | 0.882939 | 0.530420 | 62691.540000 | 71003.280000 | 313457.7 | 355016.4 |
| 71 | 2022-07-31 | Macquarie Bank Limited | 39530.4 | 119398.1 | 117431.8 | 94912.0 | 426.6 | 6336.6 | 0.983532 | 0.487392 | 2nd Tier Banks | Advanced Bank IRB | 56274.620000 | 178.64 | 2238.640000 | 0.882939 | 0.530420 | 62691.540000 | 71003.280000 | 313457.7 | 355016.4 |
| 105 | 2022-07-31 | Suncorp-Metway Limited | 31904.3 | 62021.1 | 48245.2 | 47624.2 | 0.0 | 2001.6 | 0.777884 | 0.546791 | 2nd Tier Banks | NaN | 56274.620000 | 178.64 | 2238.640000 | 0.882939 | 0.530420 | 62691.540000 | 71003.280000 | 313457.7 | 355016.4 |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 5080 | 2019-03-31 | Bendigo and Adelaide Bank Limited | 26902.4 | 55083.1 | 47020.5 | 40575.9 | 319.7 | 2721.7 | 0.853628 | 0.643849 | 2nd Tier Banks | NaN | 26229.785714 | 167.30 | 1428.628571 | 0.842480 | 0.566964 | 29869.471429 | 35454.228571 | 209086.3 | 248179.6 |
| 5128 | 2019-03-31 | Macquarie Bank Limited | 9923.6 | 50346.5 | 60503.1 | 36148.9 | 606.8 | 2287.9 | 1.201734 | 0.486677 | 2nd Tier Banks | Advanced Bank IRB | 26229.785714 | 167.30 | 1428.628571 | 0.842480 | 0.566964 | 29869.471429 | 35454.228571 | 209086.3 | 248179.6 |
| 5132 | 2019-03-31 | Members Equity Bank Limited | 8596.4 | 19387.4 | 19516.3 | 19076.6 | 163.8 | 146.9 | 1.006649 | 0.791990 | 2nd Tier Banks | NaN | 26229.785714 | 167.30 | 1428.628571 | 0.842480 | 0.566964 | 29869.471429 | 35454.228571 | 209086.3 | 248179.6 |
| 5154 | 2019-03-31 | Rural Bank Limited | 1362.4 | 4283.4 | 3392.4 | 0.1 | 0.0 | 3.8 | 0.791988 | 0.678711 | 2nd Tier Banks | NaN | 26229.785714 | 167.30 | 1428.628571 | 0.842480 | 0.566964 | 29869.471429 | 35454.228571 | 209086.3 | 248179.6 |
| 5162 | 2019-03-31 | Suncorp-Metway Limited | 21896.6 | 58364.9 | 37985.1 | 43102.2 | 2.7 | 3194.4 | 0.650821 | 0.525609 | 2nd Tier Banks | NaN | 26229.785714 | 167.30 | 1428.628571 | 0.842480 | 0.566964 | 29869.471429 | 35454.228571 | 209086.3 | 248179.6 |
242 rows × 21 columns
[NbConvertApp] Converting notebook depoinsights.ipynb to html_toc [NbConvertApp] Writing 9296436 bytes to depoinsights.html
Dash is running on http://127.0.0.1:8050/ Dash is running on http://127.0.0.1:8050/ * Serving Flask app "__main__" (lazy loading) * Environment: production WARNING: This is a development server. Do not use it in a production deployment. Use a production WSGI server instead. * Debug mode: on